BEGIN TRANSACTION
GO
ALTER TABLE dbo.Items ADD
	ItemRemarks varchar(250) NULL
GO
COMMIT

-----------------------------------

ALTER VIEW [dbo].[vw_Items]
AS
SELECT     dbo.Items.GroupID, dbo.Groups.GroupCode, dbo.Groups.GroupName, dbo.Groups.GroupNameUrdu, dbo.Groups.Type, dbo.Items.ItemID, dbo.Items.ItemCode, dbo.Items.ItemName, 
                      dbo.Items.ItemNameUrdu, dbo.Items.Rate, dbo.Items.Discontinue, dbo.Items.UnitName, dbo.Groups.myPrinterName, dbo.Items.ItemRemarks
FROM         dbo.Groups RIGHT OUTER JOIN
                      dbo.Items ON dbo.Groups.GroupID = dbo.Items.GroupID

-----------------------------------

ALTER VIEW [dbo].[VW_Vouchers]
AS
SELECT     dbo.VoucherDetails.VoucherID, dbo.Voucher.VoucherDate, dbo.Voucher.VoucherNo, dbo.Voucher.SessionID, dbo.Voucher.Remarks AS MasterRemarks, dbo.Voucher.ReadOnly, 
                      dbo.VoucherDetails.VoucherDetailID, dbo.VoucherDetails.AccountNo, dbo.Accounts.AccountTitle, dbo.SessionInfo.SessionTitle, dbo.VoucherDetails.Remarks, 
                      CASE WHEN (dbo.VoucherDetails.DrOrCr = N'Dr') THEN dbo.VoucherDetails.Amount ELSE - 1 * dbo.VoucherDetails.Amount END AS Amount, CASE WHEN (dbo.VoucherDetails.DrOrCr = N'Dr') 
                      THEN dbo.VoucherDetails.Amount ELSE 0 END AS Debit, CASE WHEN (dbo.VoucherDetails.DrOrCr = N'Cr') THEN dbo.VoucherDetails.Amount ELSE 0 END AS Credit, dbo.VoucherDetails.DrOrCr, 
                      dbo.Accounts.ParentAccount, dbo.Voucher.BankAccountID, Accounts_1.AccountTitle AS BankAccountTitle, Accounts_1.Remarks AS BankAddress, Accounts_1.CellNo AS BankCellNo, 
                      Accounts_1.Phone AS BankPhone, ISNULL(dbo.Voucher.CustomerName, '') AS CustomerName, dbo.Voucher.Amount AS VoucherAmount, dbo.Voucher.TotalAmount, dbo.Voucher.NetAmount, 
                      dbo.Voucher.ServiceCharges, dbo.Voucher.Discount, dbo.Voucher.LoginID, dbo.Employees.EmployeeName, dbo.Voucher.HostName, dbo.Voucher.EntryDateTime, dbo.vw_Items.GroupID, 
                      dbo.vw_Items.GroupCode, dbo.vw_Items.GroupName, dbo.vw_Items.GroupNameUrdu, dbo.vw_Items.Type AS ProductType, dbo.VoucherDetails.ItemID, dbo.vw_Items.ItemCode, 
                      dbo.vw_Items.ItemName, dbo.vw_Items.ItemNameUrdu, dbo.vw_Items.UnitName AS ItemUnitName, dbo.VoucherDetails.Qty, dbo.VoucherDetails.Rate, dbo.VoucherDetails.Amount AS ActualAmount, 
                      dbo.Voucher.UnitID, dbo.Unit.UnitCode, dbo.Unit.UnitName, dbo.Unit.UnitNameUrdu, dbo.Unit.AreaID, dbo.Area.AreaCode, dbo.Area.AreaName, dbo.Area.AreaNameUrdu, dbo.Voucher.KOTNo2, 
                      dbo.Voucher.ModifyID, dbo.Voucher.ModifyHost, dbo.Voucher.ModifyDateTime, dbo.Voucher.OrderType, dbo.Voucher.CellNo, dbo.Voucher.Address, dbo.Voucher.BillDate, dbo.Voucher.ShiftCID, 
                      dbo.Voucher.ShiftID, dbo.Voucher.GST, dbo.Voucher.Cash, dbo.Voucher.RefVNo, dbo.Shift.ShiftCode, dbo.Shift.ShiftName, dbo.SessionInfo.CurrentSession, dbo.vw_Items.ItemRemarks
FROM         dbo.Voucher LEFT OUTER JOIN
                      dbo.Shift ON dbo.Voucher.ShiftID = dbo.Shift.ShiftID LEFT OUTER JOIN
                      dbo.Unit LEFT OUTER JOIN
                      dbo.Area ON dbo.Unit.AreaID = dbo.Area.AreaID ON dbo.Voucher.UnitID = dbo.Unit.UnitID LEFT OUTER JOIN
                      dbo.Accounts AS Accounts_1 ON dbo.Voucher.BankAccountID = Accounts_1.AccountNo LEFT OUTER JOIN
                      dbo.Employees ON dbo.Voucher.LoginID = dbo.Employees.EmployeeID RIGHT OUTER JOIN
                      dbo.Accounts RIGHT OUTER JOIN
                      dbo.VoucherDetails LEFT OUTER JOIN
                      dbo.vw_Items ON dbo.VoucherDetails.ItemID = dbo.vw_Items.ItemID ON dbo.Accounts.AccountNo = dbo.VoucherDetails.AccountNo ON 
                      dbo.Voucher.VoucherID = dbo.VoucherDetails.VoucherID LEFT OUTER JOIN
                      dbo.SessionInfo ON dbo.Voucher.SessionID = dbo.SessionInfo.SessionID

-----------------------------------

ALTER VIEW [dbo].[VW_KOTs]
AS
SELECT     dbo.KOT.KOTID, dbo.KOT.KOTDate, dbo.KOT.KOTNo, dbo.KOT.IsBilled, dbo.KOT.LoginID, dbo.KOT.HostName, dbo.KOT.EntryDateTime, dbo.KOT.UnitID, dbo.Unit.UnitCode, dbo.Unit.UnitName, 
                      dbo.Unit.UnitNameUrdu, dbo.Unit.AreaID, dbo.Area.AreaCode, dbo.Area.AreaName, dbo.Area.AreaNameUrdu, dbo.KOTDetail.KOTDetailID, dbo.KOTDetail.AccountNo, dbo.Accounts.AccountTitle, 
                      dbo.KOTDetail.ItemID, dbo.vw_Items.ItemCode, dbo.vw_Items.ItemName, dbo.vw_Items.ItemNameUrdu, dbo.vw_Items.GroupID, dbo.vw_Items.GroupCode, dbo.vw_Items.GroupName, 
                      dbo.vw_Items.GroupNameUrdu, dbo.vw_Items.Type, dbo.vw_Items.UnitName AS ItemUnitName, dbo.KOTDetail.Qty, dbo.KOTDetail.Rate, dbo.KOTDetail.Amount, dbo.KOT.KOTNo2, 
                      dbo.KOT.ModifyID, dbo.KOT.ModifyHost, dbo.KOT.ModifyDateTime, dbo.KOTDetail.IsPrint, dbo.KOTDetail.IsDel, dbo.KOT.OrderType, dbo.KOT.CellNo, dbo.KOT.CustomerName, dbo.KOT.Address, 
                      dbo.KOT.ShiftCID, dbo.KOT.ShiftID, dbo.KOT.Amount AS vAmount, dbo.KOT.GST, dbo.KOT.ServiceCharges, dbo.KOT.TotalAmount, dbo.KOT.Discount, dbo.KOT.NetAmount, dbo.Shift.ShiftCode, 
                      dbo.Shift.ShiftName, dbo.vw_Items.myPrinterName, dbo.KOT.Status, dbo.vw_Items.ItemRemarks
FROM         dbo.vw_Items RIGHT OUTER JOIN
                      dbo.KOT INNER JOIN
                      dbo.KOTDetail ON dbo.KOT.KOTID = dbo.KOTDetail.KOTID LEFT OUTER JOIN
                      dbo.Shift ON dbo.KOT.ShiftID = dbo.Shift.ShiftID ON dbo.vw_Items.ItemID = dbo.KOTDetail.ItemID LEFT OUTER JOIN
                      dbo.Area INNER JOIN
                      dbo.Unit ON dbo.Area.AreaID = dbo.Unit.AreaID ON dbo.KOT.UnitID = dbo.Unit.UnitID LEFT OUTER JOIN
                      dbo.Accounts ON dbo.KOTDetail.AccountNo = dbo.Accounts.AccountNo

-----------------------------------